Parts · Full · Next ▶

top

In SQL, a window function or analytic functioncite-ref-1-1-0[1] is a function which uses values from one or multiple rows to return a value for each row. (This contrasts with an aggregate function, which returns a single value for multiple rows.) Window functions have an OVER clause; any function without an OVER clause is not a window function, but rather an aggregate or single-row (scalar) function.cite-ref-2[2]

• Example

• Syntax

• Example

• History

• See also

• References

As an example, here is a query which uses a window function to compare the salary of each employee with the average salary of their department (example from the PostgreSQL documentation):cite-ref-3[3]

Output:

Parts · Full · Next ▶